import pandas as pd

# 读取Excel文件

df = pd.read_excel(r'F:\XUKE\Python\zuoye\ZY1\2023-09-13.xlsx')

# 筛选温度列中大于32小于55的数据
filtered_df = df[(df['温度'] > 32) & (df['温度'] < 55)]

# 显示筛选后的数据
print(filtered_df)
